web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Power BI report import...
Power Apps - Microsoft Dataverse
Unanswered

Power BI report import Dataverse : Datasource error with invalid column name

(0) ShareShare
ReportReport
Posted on by Nealsum 14

Hi all,

 

When I create a new Power BI report using the Dataverse table, it shows below error.

 

I can use that table data in power apps without problem, i have double checked the table relationships, no issue as well

 

Extract my relationship table detected by power PI, which are matched with Dataverse relationship setting.

 

Nealsum_1-1671465472186.png

 

Nealsum_2-1671465683486.png

 

 

 

Categories:
Microsoft Dataverse
I have the same question (0)
  • AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on at
    Re: Power BI report import Dataverse : Datasource error with invalid column name

    Hello, @Nealsum, do you have  a column named cr8d8_Payroll or cr8d8_PayrollName?

  • Nealsum Profile Picture
    Nealsum 14 on at
    Re: Power BI report import Dataverse : Datasource error with invalid column name

    Hi AhmedSalih,

     

    i do created it few weeks ago when i setup the table, then i rename the column as staffpayroll, after that, i insert records from my legacy ms access database without issues

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans