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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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

(0) ShareShare
ReportReport
Posted on by 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

 

 

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,680 Moderator on at

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

  • Nealsum Profile Picture
    14 on at

    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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard